package com.kim.rssreader.domain.constant;

public class SubscriptionContant {

	public static final String TABLE_NAME = "rss_subscription";

	public static final String KEY = "_id"; // 逻辑主键

	public static final String COLUMNID = "_columnid";

	public static final String COLUMNATTENTION = "_columnattention"; // 栏目关注度

	public static final String ADDDATE = "_adddate";

	public static final int COLUMN_KEY = 0;
	public static final int COLUMN_COLUMID = 1;
	public static final int COLUMN_COLUMNATTENTION = 2;
	public static final int COLUMN_ADDDATE = 3;

	public static final String[] COLUMNS = new String[] { KEY, COLUMNID,
			COLUMNATTENTION, ADDDATE };

	public static final String SQL_CREATE = "CREATE  TABLE IF NOT EXISTS `rss_subscription` ("
			+ "`_id` INTEGER PRIMARY KEY AUTOINCREMENT,"
			+ "`_columnid` VARCHAR(36) NOT NULL,"
			+ "`_columnattention` INTEGER,"
			+ "`_adddate` timestamp" + ")";

}
